﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class welcome : System.Web.UI.Page
{
    public string img = "100";
    protected void Page_Load(object sender, EventArgs e)
    {
        using(MyDb.Db db=new MyDb.Db())
        {
            using (SqlDataReader rs = db.getList(string.Format("select ProviderID from Busevent where BusID='{0}' and RouteID='{1}' and GoBack='{2}' and City='{3}'",
                Request.Cookies["JoySpots"].Values["busid"], Request.Cookies["JoySpots"].Values["rtid"], Request.Cookies["JoySpots"].Values["gob"], Request.Cookies["JoySpots"].Values["city"])))
            {
                if (rs.Read())
                {
                    img = rs["ProviderID"].ToString();
                }
                rs.Close();
            }
        }
    }
}
